﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spm_DeleteNotification')
	BEGIN
		DROP  Procedure  spm_DeleteNotification
	END

GO

CREATE Procedure spm_DeleteNotification
@NotifId int
AS

delete Notifications where [NotifId]=@NotifId

return 0;

GO
 